Pandas Profiling Report: DataSet2

Dataset statistics

Number of variables	20
Number of observations	1190
Missing cells	2341
Missing cells (%)	9.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	169.8 KiB
Average record size in memory	146.1 B

Variable types

Numeric	12
Categorical	5
Unsupported	1
Boolean	2

Alerts

`name` has a high cardinality: 1190 distinct values	High cardinality
`url` has a high cardinality: 1190 distinct values	High cardinality
`first_series_time` has a high cardinality: 121 distinct values	High cardinality
`peak_time` has a high cardinality: 130 distinct values	High cardinality
`tournaments_list` has a high cardinality: 697 distinct values	High cardinality
`id` is highly correlated with `elo` and 5 other fields	High correlation
`elo` is highly correlated with `id` and 7 other fields	High correlation
`rank` is highly correlated with `elo` and 7 other fields	High correlation
`voobly_id` is highly correlated with `id` and 2 other fields	High correlation
`first_series_timestamp` is highly correlated with `id` and 4 other fields	High correlation
`peak_timestamp` is highly correlated with `id` and 4 other fields	High correlation
`peak_elo` is highly correlated with `elo` and 6 other fields	High correlation
`series_played` is highly correlated with `elo` and 5 other fields	High correlation
`series_won` is highly correlated with `elo` and 5 other fields	High correlation
`games_played` is highly correlated with `elo` and 5 other fields	High correlation
`tournaments_played` is highly correlated with `elo` and 6 other fields	High correlation
`inactive` is highly correlated with `id` and 7 other fields	High correlation
`retired` is highly correlated with `id` and 4 other fields	High correlation
`voobly_id` has 1095 (92.0%) missing values	Missing
`steam_id` has 1190 (100.0%) missing values	Missing
`first_series_timestamp` has 14 (1.2%) missing values	Missing
`first_series_time` has 14 (1.2%) missing values	Missing
`peak_timestamp` has 14 (1.2%) missing values	Missing
`peak_time` has 14 (1.2%) missing values	Missing
`Unnamed: 0` is uniformly distributed	Uniform
`name` is uniformly distributed	Uniform
`url` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`id` has unique values	Unique
`name` has unique values	Unique
`url` has unique values	Unique
`steam_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`series_played` has 14 (1.2%) zeros	Zeros
`series_won` has 594 (49.9%) zeros	Zeros
`games_played` has 19 (1.6%) zeros	Zeros
`tournaments_played` has 14 (1.2%) zeros	Zeros

Reproduction

Analysis started	2022-12-06 21:53:19.555496
Analysis finished	2022-12-06 21:54:13.725344
Duration	54.17 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	1190
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	594.5

Minimum	0
Maximum	1189
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	0
5-th percentile	59.45
Q1	297.25
median	594.5
Q3	891.75
95-th percentile	1129.55
Maximum	1189
Range	1189
Interquartile range (IQR)	594.5

Descriptive statistics

Standard deviation	343.6677174
Coefficient of variation (CV)	0.5780785827
Kurtosis	-1.2
Mean	594.5
Median Absolute Deviation (MAD)	297.5
Skewness	0
Sum	707455
Variance	118107.5
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	0.1%
799	1	0.1%
797	1	0.1%
796	1	0.1%
795	1	0.1%
794	1	0.1%
793	1	0.1%
792	1	0.1%
791	1	0.1%
790	1	0.1%
Other values (1180)	1180	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%

Value	Count	Frequency (%)
1189	1	0.1%
1188	1	0.1%
1187	1	0.1%
1186	1	0.1%
1185	1	0.1%
1184	1	0.1%
1183	1	0.1%
1182	1	0.1%
1181	1	0.1%
1180	1	0.1%

id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	1190
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	661.502521

Minimum	1
Maximum	1294
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	1
5-th percentile	74.45
Q1	348.25
median	667.5
Q3	975.75
95-th percentile	1231.55
Maximum	1294
Range	1293
Interquartile range (IQR)	627.5

Descriptive statistics

Standard deviation	368.6347662
Coefficient of variation (CV)	0.5572688757
Kurtosis	-1.166411888
Mean	661.502521
Median Absolute Deviation (MAD)	313.5
Skewness	-0.03979564987
Sum	787188
Variance	135891.5908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
767	1	0.1%
253	1	0.1%
1091	1	0.1%
1268	1	0.1%
1224	1	0.1%
1200	1	0.1%
686	1	0.1%
482	1	0.1%
126	1	0.1%
338	1	0.1%
Other values (1180)	1180	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%
10	1	0.1%

Value	Count	Frequency (%)
1294	1	0.1%
1293	1	0.1%
1292	1	0.1%
1291	1	0.1%
1290	1	0.1%
1289	1	0.1%
1288	1	0.1%
1287	1	0.1%
1286	1	0.1%
1285	1	0.1%

name
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	1190
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	9.4 KiB

000189AKM	1
psNps	1
Project Exile	1
Professor4k	1
prisma09	1
Other values (1185)	1185

Length

Max length	19
Median length	15
Mean length	7.307563025
Min length	2

Characters and Unicode

Total characters	8696
Distinct characters	95
Distinct categories	10 ?
Distinct scripts	3 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1190 ?
Unique (%)	100.0%

Sample

1st row	000189AKM
2nd row	000201AKM
3rd row	000934AKM
4th row	2scareD
5th row	31_

Common Values

Value	Count	Frequency (%)
000189AKM	1	0.1%
psNps	1	0.1%
Project Exile	1	0.1%
Professor4k	1	0.1%
prisma09	1	0.1%
pren	1	0.1%
Prelude	1	0.1%
Pray_4yourlife	1	0.1%
PraYs	1	0.1%
pRaXiS	1	0.1%
Other values (1180)	1180	99.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	4	0.3%
rex	2	0.2%
wrath	2	0.2%
tobi	2	0.2%
of	2	0.2%
mr	2	0.2%
chris	2	0.2%
nick	2	0.2%
escape	2	0.2%
lion	2	0.2%
Other values (1215)	1215	98.2%

Most occurring characters

Value	Count	Frequency (%)
a	723	8.3%
e	690	7.9%
o	566	6.5%
i	553	6.4%
r	462	5.3%
n	436	5.0%
l	346	4.0%
s	296	3.4%
t	289	3.3%
_	274	3.2%
Other values (85)	4061	46.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6368	73.2%
Uppercase Letter	1753	20.2%
Connector Punctuation	274	3.2%
Decimal Number	209	2.4%
Space Separator	50	0.6%
Other Letter	24	0.3%
Other Punctuation	7	0.1%
Open Punctuation	5	0.1%
Close Punctuation	5	0.1%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	723	11.4%
e	690	10.8%
o	566	8.9%
i	553	8.7%
r	462	7.3%
n	436	6.8%
l	346	5.4%
s	296	4.6%
t	289	4.5%
u	233	3.7%
Other values (21)	1774	27.9%

Uppercase Letter

Value	Count	Frequency (%)
S	155	8.8%
M	121	6.9%
T	117	6.7%
D	107	6.1%
A	107	6.1%
R	105	6.0%
C	104	5.9%
N	90	5.1%
B	84	4.8%
K	76	4.3%
Other values (16)	687	39.2%

Other Letter

Value	Count	Frequency (%)
小	3	12.5%
林	2	8.3%
臭	1	4.2%
阿	1	4.2%
金	1	4.2%
龍	1	4.2%
潭	1	4.2%
城	1	4.2%
哈	1	4.2%
周	1	4.2%
Other values (11)	11	45.8%

Decimal Number

Value	Count	Frequency (%)
0	51	24.4%
2	33	15.8%
1	33	15.8%
3	23	11.0%
4	21	10.0%
5	13	6.2%
9	12	5.7%
8	11	5.3%
6	7	3.3%
7	5	2.4%

Other Punctuation

Value	Count	Frequency (%)
.	6	85.7%
:	1	14.3%

Connector Punctuation

Value	Count	Frequency (%)
_	274	100.0%

Space Separator

Value	Count	Frequency (%)
	50	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	5	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	5	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8121	93.4%
Common	551	6.3%
Han	24	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	723	8.9%
e	690	8.5%
o	566	7.0%
i	553	6.8%
r	462	5.7%
n	436	5.4%
l	346	4.3%
s	296	3.6%
t	289	3.6%
u	233	2.9%
Other values (47)	3527	43.4%

Han

Value	Count	Frequency (%)
小	3	12.5%
林	2	8.3%
臭	1	4.2%
阿	1	4.2%
金	1	4.2%
龍	1	4.2%
潭	1	4.2%
城	1	4.2%
哈	1	4.2%
周	1	4.2%
Other values (11)	11	45.8%

Common

Value	Count	Frequency (%)
_	274	49.7%
0	51	9.3%
	50	9.1%
2	33	6.0%
1	33	6.0%
3	23	4.2%
4	21	3.8%
5	13	2.4%
9	12	2.2%
8	11	2.0%
Other values (7)	30	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8663	99.6%
CJK	24	0.3%
None	9	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	723	8.3%
e	690	8.0%
o	566	6.5%
i	553	6.4%
r	462	5.3%
n	436	5.0%
l	346	4.0%
s	296	3.4%
t	289	3.3%
_	274	3.2%
Other values (59)	4028	46.5%

None

Value	Count	Frequency (%)
é	3	33.3%
ä	3	33.3%
ì	1	11.1%
ï	1	11.1%
ô	1	11.1%

CJK

Value	Count	Frequency (%)
小	3	12.5%
林	2	8.3%
臭	1	4.2%
阿	1	4.2%
金	1	4.2%
龍	1	4.2%
潭	1	4.2%
城	1	4.2%
哈	1	4.2%
周	1	4.2%
Other values (11)	11	45.8%

elo
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	221
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1930.588235

Minimum	1853
Maximum	2357
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	1853
5-th percentile	1884
Q1	1894
median	1898
Q3	1956.75
95-th percentile	2050.55
Maximum	2357
Range	504
Interquartile range (IQR)	62.75

Descriptive statistics

Standard deviation	69.67952734
Coefficient of variation (CV)	0.03609238162
Kurtosis	9.949129223
Mean	1930.588235
Median Absolute Deviation (MAD)	7
Skewness	2.791765093
Sum	2297400
Variance	4855.236531
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1896	150	12.6%
1894	91	7.6%
1897	70	5.9%
1898	61	5.1%
1900	41	3.4%
1891	36	3.0%
1892	34	2.9%
1888	29	2.4%
1901	27	2.3%
1899	26	2.2%
Other values (211)	625	52.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1853	1	0.1%
1858	1	0.1%
1860	1	0.1%
1863	1	0.1%
1866	1	0.1%
1867	2	0.2%
1868	1	0.1%
1870	1	0.1%
1871	1	0.1%
1872	2	0.2%

Value	Count	Frequency (%)
2357	1	0.1%
2345	1	0.1%
2336	1	0.1%
2326	2	0.2%
2323	1	0.1%
2318	1	0.1%
2289	1	0.1%
2285	1	0.1%
2266	1	0.1%
2261	1	0.1%

rank
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	237
Distinct (%)	19.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	824.3798319

Minimum	1
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	1
5-th percentile	60.45
Q1	999
median	999
Q3	999
95-th percentile	999
Maximum	999
Range	998
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	352.5418362
Coefficient of variation (CV)	0.4276449066
Kurtosis	0.4269363566
Mean	824.3798319
Median Absolute Deviation (MAD)	0
Skewness	-1.542887266
Sum	981012
Variance	124285.7463
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
999	954	80.2%
177	1	0.1%
180	1	0.1%
42	1	0.1%
202	1	0.1%
81	1	0.1%
28	1	0.1%
161	1	0.1%
104	1	0.1%
220	1	0.1%
Other values (227)	227	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%
10	1	0.1%

Value	Count	Frequency (%)
999	954	80.2%
236	1	0.1%
235	1	0.1%
234	1	0.1%
233	1	0.1%
232	1	0.1%
231	1	0.1%
230	1	0.1%
229	1	0.1%
228	1	0.1%

url
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	1190
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	9.4 KiB

https://aoe-elo.com/player/767/000189AKM	1
https://aoe-elo.com/player/253/psNps	1
https://aoe-elo.com/player/1091/Project-Exile	1
https://aoe-elo.com/player/1268/Professor4k	1
https://aoe-elo.com/player/1224/prisma09	1
Other values (1185)	1185

Length

Max length	51
Median length	47
Mean length	38.51428571
Min length	32

Characters and Unicode

Total characters	45832
Distinct characters	66
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1190 ?
Unique (%)	100.0%

Sample

1st row	https://aoe-elo.com/player/767/000189AKM
2nd row	https://aoe-elo.com/player/777/000201AKM
3rd row	https://aoe-elo.com/player/763/000934AKM
4th row	https://aoe-elo.com/player/259/2scareD
5th row	https://aoe-elo.com/player/451/31-

Common Values

Value	Count	Frequency (%)
https://aoe-elo.com/player/767/000189AKM	1	0.1%
https://aoe-elo.com/player/253/psNps	1	0.1%
https://aoe-elo.com/player/1091/Project-Exile	1	0.1%
https://aoe-elo.com/player/1268/Professor4k	1	0.1%
https://aoe-elo.com/player/1224/prisma09	1	0.1%
https://aoe-elo.com/player/1200/pren	1	0.1%
https://aoe-elo.com/player/686/Prelude	1	0.1%
https://aoe-elo.com/player/482/Pray-4yourlife	1	0.1%
https://aoe-elo.com/player/126/PraYs	1	0.1%
https://aoe-elo.com/player/338/pRaXiS	1	0.1%
Other values (1180)	1180	99.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://aoe-elo.com/player/767/000189akm	1	0.1%
https://aoe-elo.com/player/763/000934akm	1	0.1%
https://aoe-elo.com/player/451/31	1	0.1%
https://aoe-elo.com/player/843/3nvy	1	0.1%
https://aoe-elo.com/player/466/7demons	1	0.1%
https://aoe-elo.com/player/56/8th-wonder	1	0.1%
https://aoe-elo.com/player/1129/a220541515	1	0.1%
https://aoe-elo.com/player/561/aaiioo	1	0.1%
https://aoe-elo.com/player/844/aa-nike	1	0.1%
https://aoe-elo.com/player/515/abe	1	0.1%
Other values (1180)	1180	99.2%

Most occurring characters

Value	Count	Frequency (%)
/	5950	13.0%
e	4260	9.3%
o	4136	9.0%
a	3103	6.8%
l	2726	5.9%
t	2669	5.8%
p	2496	5.4%
r	1652	3.6%
-	1622	3.5%
s	1486	3.2%
Other values (56)	15732	34.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	30159	65.8%
Other Punctuation	8330	18.2%
Decimal Number	3968	8.7%
Uppercase Letter	1753	3.8%
Dash Punctuation	1622	3.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4260	14.1%
o	4136	13.7%
a	3103	10.3%
l	2726	9.0%
t	2669	8.8%
p	2496	8.3%
r	1652	5.5%
s	1486	4.9%
h	1410	4.7%
c	1365	4.5%
Other values (16)	4856	16.1%

Uppercase Letter

Value	Count	Frequency (%)
S	155	8.8%
M	121	6.9%
T	117	6.7%
A	107	6.1%
D	107	6.1%
R	105	6.0%
C	104	5.9%
N	90	5.1%
B	84	4.8%
K	76	4.3%
Other values (16)	687	39.2%

Decimal Number

Value	Count	Frequency (%)
1	728	18.3%
2	453	11.4%
0	376	9.5%
4	359	9.0%
3	356	9.0%
5	344	8.7%
8	343	8.6%
6	338	8.5%
9	337	8.5%
7	334	8.4%

Other Punctuation

Value	Count	Frequency (%)
/	5950	71.4%
:	1190	14.3%
.	1190	14.3%

Dash Punctuation

Value	Count	Frequency (%)
-	1622	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	31912	69.6%
Common	13920	30.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4260	13.3%
o	4136	13.0%
a	3103	9.7%
l	2726	8.5%
t	2669	8.4%
p	2496	7.8%
r	1652	5.2%
s	1486	4.7%
h	1410	4.4%
c	1365	4.3%
Other values (42)	6609	20.7%

Common

Value	Count	Frequency (%)
/	5950	42.7%
-	1622	11.7%
:	1190	8.5%
.	1190	8.5%
1	728	5.2%
2	453	3.3%
0	376	2.7%
4	359	2.6%
3	356	2.6%
5	344	2.5%
Other values (4)	1352	9.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	45832	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	5950	13.0%
e	4260	9.3%
o	4136	9.0%
a	3103	6.8%
l	2726	5.9%
t	2669	5.8%
p	2496	5.4%
r	1652	3.6%
-	1622	3.5%
s	1486	3.2%
Other values (56)	15732	34.3%

voobly_id
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	95
Distinct (%)	100.0%
Missing	1095
Missing (%)	92.0%
Infinite	0
Infinite (%)	0.0%
Mean	96393527.33

Minimum	523
Maximum	125101127
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	523
5-th percentile	4117.2
Q1	123160364
median	123444726
Q3	123924317.5
95-th percentile	124543846.3
Maximum	125101127
Range	125100604
Interquartile range (IQR)	763953.5

Descriptive statistics

Standard deviation	51592839.16
Coefficient of variation (CV)	0.5352313645
Kurtosis	-0.1372811508
Mean	96393527.33
Median Absolute Deviation (MAD)	465457
Skewness	-1.365888318
Sum	9157385096
Variance	2.661821053 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
123737920	1	0.1%
123497926	1	0.1%
123225139	1	0.1%
124653323	1	0.1%
124827272	1	0.1%
123174138	1	0.1%
123417449	1	0.1%
5469	1	0.1%
56531	1	0.1%
123222710	1	0.1%
Other values (85)	85	7.1%
(Missing)	1095	92.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
523	1	0.1%
610	1	0.1%
722	1	0.1%
817	1	0.1%
963	1	0.1%
5469	1	0.1%
5958	1	0.1%
9267	1	0.1%
11486	1	0.1%
12926	1	0.1%

Value	Count	Frequency (%)
125101127	1	0.1%
124954867	1	0.1%
124827272	1	0.1%
124653323	1	0.1%
124646628	1	0.1%
124499797	1	0.1%
124474647	1	0.1%
124434755	1	0.1%
124386524	1	0.1%
124244937	1	0.1%

steam_id
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1190
Missing (%)	100.0%
Memory size	9.4 KiB

first_series_timestamp
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	329
Distinct (%)	28.0%
Missing	14
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%
Mean	1370285485

Minimum	965260800
Maximum	1665878400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	965260800
5-th percentile	997574399
Q1	1082851200
median	1426161600
Q3	1612828800
95-th percentile	1649376000
Maximum	1665878400
Range	700617600
Interquartile range (IQR)	529977600

Descriptive statistics

Standard deviation	251478248.3
Coefficient of variation (CV)	0.1835225221
Kurtosis	-1.591971246
Mean	1370285485
Median Absolute Deviation (MAD)	197553600
Skewness	-0.3097189565
Sum	1.611455731 × 10¹²
Variance	6.324130937 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1622851200	41	3.4%
1622246400	40	3.4%
1075766399	39	3.3%
1007596800	32	2.7%
1036454399	25	2.1%
1200268799	24	2.0%
1587168000	24	2.0%
1408320000	21	1.8%
1262303999	21	1.8%
1376179200	20	1.7%
Other values (319)	889	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
965260800	2	0.2%
965433600	2	0.2%
965520000	10	0.8%
965606400	4	0.3%
965692800	4	0.3%
965779200	2	0.2%
965952000	4	0.3%
966729600	2	0.2%
971654399	3	0.3%
983750399	14	1.2%

Value	Count	Frequency (%)
1665878400	1	0.1%
1665792000	1	0.1%
1665705600	2	0.2%
1665619200	1	0.1%
1665532800	2	0.2%
1665360000	1	0.1%
1665187200	1	0.1%
1665100800	1	0.1%
1663977600	2	0.2%
1663891200	1	0.1%

first_series_time
Categorical

HIGH CARDINALITY
MISSING

Distinct	121
Distinct (%)	10.3%
Missing	14
Missing (%)	1.2%
Memory size	9.4 KiB

Jun 2021	68
May 2021	59
Apr 2020	54
Feb 2004	39
Aug 2020	38
Other values (116)	918

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	9408
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	1.0%

Sample

1st row	Nov 2002
2nd row	Nov 2002
3rd row	Nov 2002
4th row	Apr 2003
5th row	Mar 2010

Common Values

Value	Count	Frequency (%)
Jun 2021	68	5.7%
May 2021	59	5.0%
Apr 2020	54	4.5%
Feb 2004	39	3.3%
Aug 2020	38	3.2%
Dec 2001	32	2.7%
Aug 2000	30	2.5%
Nov 2002	25	2.1%
Oct 2021	25	2.1%
Jan 2008	24	2.0%
Other values (111)	782	65.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021	238	10.1%
2020	168	7.1%
aug	161	6.8%
apr	141	6.0%
jan	129	5.5%
dec	117	5.0%
jun	116	4.9%
may	106	4.5%
oct	91	3.9%
2022	86	3.7%
Other values (25)	999	42.5%

Most occurring characters

Value	Count	Frequency (%)
2	1847	19.6%
0	1846	19.6%
	1176	12.5%
1	549	5.8%
u	362	3.8%
J	330	3.5%
a	303	3.2%
A	302	3.2%
n	245	2.6%
e	215	2.3%
Other values (23)	2233	23.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4704	50.0%
Lowercase Letter	2352	25.0%
Space Separator	1176	12.5%
Uppercase Letter	1176	12.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	362	15.4%
a	303	12.9%
n	245	10.4%
e	215	9.1%
r	209	8.9%
c	208	8.8%
p	167	7.1%
g	161	6.8%
y	106	4.5%
t	91	3.9%
Other values (4)	285	12.1%

Decimal Number

Value	Count	Frequency (%)
2	1847	39.3%
0	1846	39.2%
1	549	11.7%
4	116	2.5%
3	105	2.2%
5	72	1.5%
7	50	1.1%
8	48	1.0%
9	45	1.0%
6	26	0.6%

Uppercase Letter

Value	Count	Frequency (%)
J	330	28.1%
A	302	25.7%
M	174	14.8%
D	117	9.9%
O	91	7.7%
F	72	6.1%
N	64	5.4%
S	26	2.2%

Space Separator

Value	Count	Frequency (%)
	1176	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5880	62.5%
Latin	3528	37.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	362	10.3%
J	330	9.4%
a	303	8.6%
A	302	8.6%
n	245	6.9%
e	215	6.1%
r	209	5.9%
c	208	5.9%
M	174	4.9%
p	167	4.7%
Other values (12)	1013	28.7%

Common

Value	Count	Frequency (%)
2	1847	31.4%
0	1846	31.4%
	1176	20.0%
1	549	9.3%
4	116	2.0%
3	105	1.8%
5	72	1.2%
7	50	0.9%
8	48	0.8%
9	45	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9408	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1847	19.6%
0	1846	19.6%
	1176	12.5%
1	549	5.8%
u	362	3.8%
J	330	3.5%
a	303	3.2%
A	302	3.2%
n	245	2.6%
e	215	2.3%
Other values (23)	2233	23.7%

peak_timestamp
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	414
Distinct (%)	35.2%
Missing	14
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%
Mean	1392408367

Minimum	965260800
Maximum	1666483200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	965260800
5-th percentile	1007596800
Q1	1105747200
median	1500681600
Q3	1622851200
95-th percentile	1660154400
Maximum	1666483200
Range	701222400
Interquartile range (IQR)	517104000

Descriptive statistics

Standard deviation	255260806.5
Coefficient of variation (CV)	0.1833232351
Kurtosis	-1.564211531
Mean	1392408367
Median Absolute Deviation (MAD)	149904000
Skewness	-0.4015797184
Sum	1.63747224 × 10¹²
Variance	6.515807931 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1622851200	44	3.7%
1075766399	42	3.5%
1622246400	33	2.8%
1036454399	30	2.5%
1007596800	28	2.4%
1635552000	23	1.9%
1200268799	21	1.8%
1262303999	18	1.5%
1587168000	18	1.5%
1597449600	17	1.4%
Other values (404)	902	75.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
965260800	1	0.1%
965433600	2	0.2%
965520000	7	0.6%
965606400	2	0.2%
965692800	2	0.2%
965779200	1	0.1%
965952000	3	0.3%
966470400	1	0.1%
966729600	2	0.2%
971654399	3	0.3%

Value	Count	Frequency (%)
1666483200	2	0.2%
1666310400	2	0.2%
1666224000	1	0.1%
1665878400	3	0.3%
1665792000	5	0.4%
1665705600	3	0.3%
1665619200	1	0.1%
1665532800	3	0.3%
1665360000	2	0.2%
1665187200	1	0.1%

peak_time
Categorical

HIGH CARDINALITY
MISSING

Distinct	130
Distinct (%)	11.1%
Missing	14
Missing (%)	1.2%
Memory size	9.4 KiB

Jun 2021	68
May 2021	49
Feb 2004	42
Apr 2020	41
Aug 2020	40
Other values (125)	936

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	9408
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	22 ?
Unique (%)	1.9%

Sample

1st row	Nov 2002
2nd row	Nov 2002
3rd row	Nov 2002
4th row	Apr 2003
5th row	Mar 2010

Common Values

Value	Count	Frequency (%)
Jun 2021	68	5.7%
May 2021	49	4.1%
Feb 2004	42	3.5%
Apr 2020	41	3.4%
Aug 2020	40	3.4%
Oct 2021	34	2.9%
Apr 2022	31	2.6%
Nov 2002	30	2.5%
Dec 2001	29	2.4%
Oct 2022	27	2.3%
Other values (120)	785	66.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021	249	10.6%
2022	167	7.1%
aug	163	6.9%
2020	145	6.2%
apr	134	5.7%
jan	123	5.2%
jun	112	4.8%
oct	108	4.6%
dec	105	4.5%
may	97	4.1%
Other values (25)	949	40.3%

Most occurring characters

Value	Count	Frequency (%)
2	1989	21.1%
0	1794	19.1%
	1176	12.5%
1	501	5.3%
u	364	3.9%
J	324	3.4%
A	297	3.2%
a	282	3.0%
n	235	2.5%
e	224	2.4%
Other values (23)	2222	23.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4704	50.0%
Lowercase Letter	2352	25.0%
Space Separator	1176	12.5%
Uppercase Letter	1176	12.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	364	15.5%
a	282	12.0%
n	235	10.0%
e	224	9.5%
c	213	9.1%
r	196	8.3%
p	172	7.3%
g	163	6.9%
t	108	4.6%
y	97	4.1%
Other values (4)	298	12.7%

Decimal Number

Value	Count	Frequency (%)
2	1989	42.3%
0	1794	38.1%
1	501	10.7%
4	113	2.4%
3	83	1.8%
5	76	1.6%
8	47	1.0%
7	41	0.9%
9	34	0.7%
6	26	0.6%

Uppercase Letter

Value	Count	Frequency (%)
J	324	27.6%
A	297	25.3%
M	159	13.5%
O	108	9.2%
D	105	8.9%
F	81	6.9%
N	64	5.4%
S	38	3.2%

Space Separator

Value	Count	Frequency (%)
	1176	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5880	62.5%
Latin	3528	37.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	364	10.3%
J	324	9.2%
A	297	8.4%
a	282	8.0%
n	235	6.7%
e	224	6.3%
c	213	6.0%
r	196	5.6%
p	172	4.9%
g	163	4.6%
Other values (12)	1058	30.0%

Common

Value	Count	Frequency (%)
2	1989	33.8%
0	1794	30.5%
	1176	20.0%
1	501	8.5%
4	113	1.9%
3	83	1.4%
5	76	1.3%
8	47	0.8%
7	41	0.7%
9	34	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9408	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1989	21.1%
0	1794	19.1%
	1176	12.5%
1	501	5.3%
u	364	3.9%
J	324	3.4%
A	297	3.2%
a	282	3.0%
n	235	2.5%
e	224	2.4%
Other values (23)	2222	23.6%

peak_elo
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	168
Distinct (%)	14.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1942.153782

Minimum	1880
Maximum	2395
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	1880
5-th percentile	1892
Q1	1896
median	1900.5
Q3	1994.75
95-th percentile	2071.55
Maximum	2395
Range	515
Interquartile range (IQR)	98.75

Descriptive statistics

Standard deviation	78.12187142
Coefficient of variation (CV)	0.04022434895
Kurtosis	7.20981157
Mean	1942.153782
Median Absolute Deviation (MAD)	6.5
Skewness	2.378947128
Sum	2311163
Variance	6103.026794
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1896	181	15.2%
1894	108	9.1%
1897	100	8.4%
1898	58	4.9%
1904	54	4.5%
1891	44	3.7%
1900	35	2.9%
1899	26	2.2%
1892	26	2.2%
1996	22	1.8%
Other values (158)	536	45.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1880	1	0.1%
1885	2	0.2%
1888	10	0.8%
1890	1	0.1%
1891	44	3.7%
1892	26	2.2%
1893	2	0.2%
1894	108	9.1%
1895	1	0.1%
1896	181	15.2%

Value	Count	Frequency (%)
2395	1	0.1%
2384	1	0.1%
2371	1	0.1%
2357	1	0.1%
2349	1	0.1%
2340	1	0.1%
2333	1	0.1%
2306	1	0.1%
2305	1	0.1%
2296	1	0.1%

inactive
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.3 KiB

True	871
False	319

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	871	73.2%
False	319	26.8%

retired
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.3 KiB

True	657
False	533

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	657	55.2%
False	533	44.8%

series_played
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	108
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.88571429

Minimum	0
Maximum	486
Zeros	14
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	3
Q3	9
95-th percentile	66
Maximum	486
Range	486
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	41.54103079
Coefficient of variation (CV)	2.790664256
Kurtosis	43.45872282
Mean	14.88571429
Median Absolute Deviation (MAD)	2
Skewness	5.931018445
Sum	17714
Variance	1725.657239
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	403	33.9%
2	141	11.8%
3	103	8.7%
5	69	5.8%
4	65	5.5%
8	30	2.5%
6	28	2.4%
10	24	2.0%
9	22	1.8%
7	22	1.8%
Other values (98)	283	23.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	1.2%
1	403	33.9%
2	141	11.8%
3	103	8.7%
4	65	5.5%
5	69	5.8%
6	28	2.4%
7	22	1.8%
8	30	2.5%
9	22	1.8%

Value	Count	Frequency (%)
486	1	0.1%
391	1	0.1%
387	2	0.2%
351	1	0.1%
318	1	0.1%
277	1	0.1%
270	1	0.1%
249	1	0.1%
248	1	0.1%
235	1	0.1%

series_won
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	78
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.217647059

Minimum	0
Maximum	331
Zeros	594
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	3
95-th percentile	32
Maximum	331
Range	331
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	26.22399195
Coefficient of variation (CV)	3.633315918
Kurtosis	62.93328525
Mean	7.217647059
Median Absolute Deviation (MAD)	1
Skewness	7.104767386
Sum	8589
Variance	687.6977539
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	594	49.9%
1	185	15.5%
2	87	7.3%
3	52	4.4%
4	35	2.9%
5	18	1.5%
7	18	1.5%
8	16	1.3%
6	15	1.3%
14	13	1.1%
Other values (68)	157	13.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	594	49.9%
1	185	15.5%
2	87	7.3%
3	52	4.4%
4	35	2.9%
5	18	1.5%
6	15	1.3%
7	18	1.5%
8	16	1.3%
9	10	0.8%

Value	Count	Frequency (%)
331	1	0.1%
324	1	0.1%
265	1	0.1%
249	1	0.1%
206	1	0.1%
204	1	0.1%
172	1	0.1%
161	1	0.1%
160	1	0.1%
152	1	0.1%

games_played
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	183
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.51092437

Minimum	0
Maximum	1644
Zeros	19
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	5
Q3	23
95-th percentile	196.75
Maximum	1644
Range	1644
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	136.7270902
Coefficient of variation (CV)	3.142362341
Kurtosis	48.66558153
Mean	43.51092437
Median Absolute Deviation (MAD)	4
Skewness	6.286789386
Sum	51778
Variance	18694.29719
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	215	18.1%
1	125	10.5%
3	95	8.0%
4	78	6.6%
5	70	5.9%
6	42	3.5%
7	31	2.6%
8	28	2.4%
13	21	1.8%
12	20	1.7%
Other values (173)	465	39.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	1.6%
1	125	10.5%
2	215	18.1%
3	95	8.0%
4	78	6.6%
5	70	5.9%
6	42	3.5%
7	31	2.6%
8	28	2.4%
9	19	1.6%

Value	Count	Frequency (%)
1644	1	0.1%
1364	1	0.1%
1363	1	0.1%
1228	1	0.1%
1180	1	0.1%
1059	1	0.1%
919	1	0.1%
901	1	0.1%
815	1	0.1%
782	1	0.1%

tournaments_played
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	69
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.103361345

Minimum	0
Maximum	127
Zeros	14
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	9.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	5
95-th percentile	30
Maximum	127
Range	127
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	13.43139083
Coefficient of variation (CV)	2.200654699
Kurtosis	25.38008336
Mean	6.103361345
Median Absolute Deviation (MAD)	0
Skewness	4.587029648
Sum	7263
Variance	180.4022595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	620	52.1%
2	137	11.5%
3	62	5.2%
4	57	4.8%
5	42	3.5%
6	34	2.9%
7	24	2.0%
10	16	1.3%
8	16	1.3%
9	15	1.3%
Other values (59)	167	14.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	1.2%
1	620	52.1%
2	137	11.5%
3	62	5.2%
4	57	4.8%
5	42	3.5%
6	34	2.9%
7	24	2.0%
8	16	1.3%
9	15	1.3%

Value	Count	Frequency (%)
127	1	0.1%
113	1	0.1%
111	1	0.1%
106	1	0.1%
101	1	0.1%
89	1	0.1%
88	1	0.1%
86	1	0.1%
83	1	0.1%
82	1	0.1%

tournaments_list
Categorical

HIGH CARDINALITY

Distinct	697
Distinct (%)	58.6%
Missing	0
Missing (%)	0.0%
Memory size	9.4 KiB

[293]	31
[127]	27
[142]	25
[290]	19
[136]	19
Other values (692)	1069

Length

Max length	588
Median length	533
Mean length	29.46470588
Min length	2

Characters and Unicode

Total characters	35063
Distinct characters	14
Distinct categories	5 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	588 ?
Unique (%)	49.4%

Sample

1st row	[136]
2nd row	[136]
3rd row	[136]
4th row	[86, 110, 114, 115, 116, 117, 119, 121, 123, 124, 125, 126, 127, 157, 264, 285]
5th row	[86]

Common Values

Value	Count	Frequency (%)
[293]	31	2.6%
[127]	27	2.3%
[142]	25	2.1%
[290]	19	1.6%
[136]	19	1.6%
[148]	18	1.5%
[102]	16	1.3%
[343]	15	1.3%
[]	14	1.2%
[264]	14	1.2%
Other values (687)	992	83.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
293	128	1.8%
290	128	1.8%
343	126	1.7%
315	96	1.3%
291	91	1.3%
304	79	1.1%
298	78	1.1%
262	70	1.0%
127	65	0.9%
353	64	0.9%
Other values (462)	6352	87.3%

Most occurring characters

Value	Count	Frequency (%)
,	6087	17.4%
	6087	17.4%
3	3565	10.2%
1	3215	9.2%
2	3025	8.6%
4	2334	6.7%
9	1660	4.7%
6	1470	4.2%
0	1421	4.1%
7	1298	3.7%
Other values (4)	4901	14.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	20509	58.5%
Other Punctuation	6087	17.4%
Space Separator	6087	17.4%
Open Punctuation	1190	3.4%
Close Punctuation	1190	3.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	3565	17.4%
1	3215	15.7%
2	3025	14.7%
4	2334	11.4%
9	1660	8.1%
6	1470	7.2%
0	1421	6.9%
7	1298	6.3%
5	1277	6.2%
8	1244	6.1%

Other Punctuation

Value	Count	Frequency (%)
,	6087	100.0%

Space Separator

Value	Count	Frequency (%)
	6087	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	1190	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	1190	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	35063	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
,	6087	17.4%
	6087	17.4%
3	3565	10.2%
1	3215	9.2%
2	3025	8.6%
4	2334	6.7%
9	1660	4.7%
6	1470	4.2%
0	1421	4.1%
7	1298	3.7%
Other values (4)	4901	14.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35063	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
,	6087	17.4%
	6087	17.4%
3	3565	10.2%
1	3215	9.2%
2	3025	8.6%
4	2334	6.7%
9	1660	4.7%
6	1470	4.2%
0	1421	4.1%
7	1298	3.7%
Other values (4)	4901	14.0%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	id	name	elo	rank	url	voobly_id	steam_id	first_series_timestamp	first_series_time	peak_timestamp	peak_time	peak_elo	inactive	retired	series_played	series_won	games_played	tournaments_played	tournaments_list
0	0	767	000189AKM	1894	999	https://aoe-elo.com/player/767/000189AKM	NaN	NaN	1.036454e+09	Nov 2002	1.036454e+09	Nov 2002	1896	True	True	4	1	4	1	[136]
1	1	777	000201AKM	1886	999	https://aoe-elo.com/player/777/000201AKM	NaN	NaN	1.036454e+09	Nov 2002	1.036454e+09	Nov 2002	1897	True	True	4	0	4	1	[136]
2	2	763	000934AKM	1882	999	https://aoe-elo.com/player/763/000934AKM	NaN	NaN	1.036454e+09	Nov 2002	1.036454e+09	Nov 2002	1896	True	True	5	0	5	1	[136]
3	3	259	2scareD	1957	999	https://aoe-elo.com/player/259/2scareD	NaN	NaN	1.049501e+09	Apr 2003	1.049501e+09	Apr 2003	1996	True	True	31	11	84	16	[86, 110, 114, 115, 116, 117, 119, 121, 123, 124, 125, 126, 127, 157, 264, 285]
4	4	451	31_	1886	999	https://aoe-elo.com/player/451/31-	NaN	NaN	1.267834e+09	Mar 2010	1.267834e+09	Mar 2010	1893	True	True	2	0	10	1	[86]
5	5	843	3nvY	1897	999	https://aoe-elo.com/player/843/3nvY	NaN	NaN	1.039565e+09	Dec 2002	1.039565e+09	Dec 2002	1897	True	True	1	0	1	1	[137]
6	6	466	7DeMonS	1902	999	https://aoe-elo.com/player/466/7DeMonS	NaN	NaN	1.075766e+09	Feb 2004	1.075766e+09	Feb 2004	1904	True	True	3	1	7	2	[126, 127]
7	7	56	8th_wonder	1991	999	https://aoe-elo.com/player/56/8th-wonder	123737920.0	NaN	1.307923e+09	Jun 2011	1.442707e+09	Sep 2015	2039	True	True	30	11	101	10	[15, 19, 21, 29, 62, 65, 80, 84, 85, 103]
8	8	1129	a220541515	1900	999	https://aoe-elo.com/player/1129/a220541515	NaN	NaN	NaN	NaN	NaN	NaN	1900	False	False	0	0	0	0	[]
9	9	561	aaiioo	1900	999	https://aoe-elo.com/player/561/aaiioo	NaN	NaN	NaN	NaN	NaN	NaN	1900	False	False	0	0	0	0	[]

Last rows

	Unnamed: 0	id	name	elo	rank	url	voobly_id	steam_id	first_series_timestamp	first_series_time	peak_timestamp	peak_time	peak_elo	inactive	retired	series_played	series_won	games_played	tournaments_played	tournaments_list
1180	1180	862	_Tulkas	1894	999	https://aoe-elo.com/player/862/-Tulkas	NaN	NaN	1.409875e+09	Sep 2014	1.409875e+09	Sep 2014	1894	True	True	1	0	2	1	[75]
1181	1181	714	_ViRuS_PuLsE	1966	150	https://aoe-elo.com/player/714/-ViRuS-PuLsE	NaN	NaN	1.589933e+09	May 2020	1.589933e+09	May 2020	1988	False	False	8	2	29	2	[173, 368]
1182	1182	412	_ZhaZ	1995	999	https://aoe-elo.com/player/412/-ZhaZ	NaN	NaN	1.005178e+09	Nov 2001	1.012522e+09	Jan 2002	2007	True	True	12	6	12	4	[141, 142, 143, 146]
1183	1183	678	__BillaBamZilla	1900	999	https://aoe-elo.com/player/678/--BillaBamZilla	NaN	NaN	1.082851e+09	Apr 2004	1.082851e+09	Apr 2004	1904	True	True	2	1	2	1	[125]
1184	1184	1209	__I_s_I__	1899	999	https://aoe-elo.com/player/1209/--I-s-I--	NaN	NaN	1.647994e+09	Mar 2022	1.647994e+09	Mar 2022	1912	False	False	3	1	10	1	[369]
1185	1185	1193	偶像先生	1899	999	https://aoe-elo.com/player/1193/------------	NaN	NaN	1.635552e+09	Oct 2021	1.635552e+09	Oct 2021	1899	True	False	1	0	3	1	[343]
1186	1186	810	小布周	1888	999	https://aoe-elo.com/player/810/----------	NaN	NaN	1.596758e+09	Aug 2020	1.596758e+09	Aug 2020	1894	True	True	2	0	4	2	[213, 214]
1187	1187	1146	小菜鸡	1881	999	https://aoe-elo.com/player/1146/---------	NaN	NaN	1.627776e+09	Aug 2021	1.627776e+09	Aug 2021	1896	True	False	5	0	5	1	[316]
1188	1188	1130	細菌人	1900	999	https://aoe-elo.com/player/1130/---------	NaN	NaN	NaN	NaN	NaN	NaN	1900	False	False	0	0	0	0	[]
1189	1189	1131	龍潭金城武	1878	999	https://aoe-elo.com/player/1131/---------------	NaN	NaN	1.626394e+09	Jul 2021	1.626394e+09	Jul 2021	1894	True	False	5	0	9	2	[311, 343]

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Letter

Decimal Number

Other Punctuation

Connector Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Han

Common

Most occurring blocks

Most frequent character per block

ASCII

None

CJK

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories